eXtremeDB SQL Return Codes

The following SQL return codes indicate SQL-specific runtime or error conditions that might be returned by the eXtremeDB runtime while processing SQL statements:

Mnemonic Constant Name

Value

Meaning

SQL_OK

0

Successful SQL execution

NO_MORE_ELEMENTS

1

End of result set reached

INVALID_TYPE_CAST

2

Attempt to cast to an invalid SQL type

COMPILE_ERROR

3

Error compiling SQL statement

NOT_SINGLE_VALUE

4

Result set with more than one row returned

INVALID_OPERATION

5

Not a valid SQL operation

INDEX_OUT_OF_BOUNDS

6

Attempt to access outside of array bounds

NOT_ENOUGH_MEMORY

7

Out of memory executing SQL statement

NOT_UNIQUE

8

Attempt to insert a record with duplicate identifier value

NOT_PREPARED

9

Attempt to execute a pre-compiled statement that was not prepared

RUNTIME_ERROR

10

Unknown SQL runtime error

COMMUNICATION_ERROR

11

Unknown communication error

UPGRADE_NOT_POSSIBLE

12

Unable to upgrade transaction to READ_WRITE

SQL_CONFLICT

13

SQL conflict while updating a record

SQL_NULL_REFERENCE

14

Attempt to dereference a NULL reference

SQL_INVALID_STATE

15

Invalid executor state

SQL_INVALID_OPERAND

16

Invalid function operand

SQL_NULL_VALUE

17

A null value encountered in a context not accepting null values

SQL_BAD_CSV_FORMAT

18

Wrong format in CSV file

SQL_SYSTEM_ERROR

19

Internal SQL engine error

Related Topics